package com.ruoyi.finance.vo;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import com.ruoyi.common.core.annotation.Excel;
import com.ruoyi.common.core.web.domain.BaseEntity;

import java.math.BigDecimal;
import java.util.Date;

/**
 * 销售出(退)库单对象 t_commission_delivery_product
 *
 * @author admin
 * @date 2023-10-13
 */
@Data
public class CommissionDeliveryProductImport extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * 季度
     */
    @Excel(name = "季度")
    private String quarter;

    /**
     * 月份
     */
    @Excel(name = "月份")
    private String month;

    /**
     * 单据编号
     */
    @Excel(name = "单据编号")
    private String billNo;

    /**
     * 单据类型(0=出库单,1=退库单)
     */
    //@Excel(name = "单据类型(0=出库单,1=退库单)")
    private Integer billType;

    /**
     * PI号
     */
    @Excel(name = "PI号")
    private String piNo;

    /**
     * 行号
     */
    @Excel(name = "行号")
    private String lineNo;

    /**
     * 销售部门
     */
    @Excel(name = "销售部门")
    private String salesDept;

    /**
     * 销售员
     */
    @Excel(name = "销售员")
    private String salesName;
    /**
     * 组织编码
     */
    @Excel(name = "组织编码")
    private String orgCode;

    /**
     * 客户编码
     */
    @Excel(name = "客户")
    private String customerNo;

    /**
     * sku编码
     */
    @Excel(name = "物料编码")
    private String skuCode;

    /**
     * 一级品类/产品线
     */
    @Excel(name = "一级品类")
    private String productLine;

    /**
     * 二级品类/产品线
     */
    @Excel(name = "Type")
    private String type;

    /**
     * 英文名称
     */
    //@Excel(name = "英文名称")
    private String nameEn;

    /**
     * 中文名称
     */
    @Excel(name = "物料名称")
    private String nameCn;

    /**
     * 应发数量
     */
    @Excel(name = "应发数量")
    private Integer mustQty;

    /**
     * 实发数量
     */
    @Excel(name = "实发数量")
    private Integer realQty;

    /**
     * 单价
     */
    @Excel(name = "单价")
    private BigDecimal unitPrice;

    /**
     * 总价格
     */
    @Excel(name = "金额")
    private BigDecimal totalPrice;

    /**
     * 本位币总价格
     */
    @Excel(name = "金额（本位币）")
    private BigDecimal totalPriceRmb;

    /**
     * 成本价(采购执行报价)
     */
    @Excel(name = "采购执行报价")
    private BigDecimal costPrice;

    /**
     * 总成本价
     */
    @Excel(name = "总成本(本位币)")
    private BigDecimal totalCostPrice;

    /**
     * 真实成本价(采购执行报价)
     */
    @Excel(name = "销售提成单价")
    private BigDecimal realCostPrice;

    /**
     * 毛利润
     */
    @Excel(name = "毛利润")
    private BigDecimal grossMargin;

    /**
     * 真实总成本价
     */
    @Excel(name = "成本")
    private BigDecimal realTotalCostPrice;

    /**
     * 出/退库日期
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date storageDate;
    /**
     * 提成年月
     */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "年月", width = 30, dateFormat = "yyyy-MM-dd")
    private Date commissionDate;

}
